99

Merging Sheets

99

• DO Loop

• which is a special loop that executes at least once

• Workbook

• opening and saving

• Worksheets

• checking their names, copying from, copying to

• Application.FileDialogue

• Open file

• Save file

• OnError Goto Resume

• handling errors

One exercise that you might like to work on:

How do you use this model to perform the exact opposite task of splitting a spread­

sheet into multiple workbooks, so that each one is meant for a certain group identified

by a key field in the workbook such as department, city, or state?